{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='丰田')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口丰田>>']\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LFM')|(all1['3']=='LTV')|(all1['3']=='LVG')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='大众')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口大众>>']\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LFV')|(all1['3']=='LSV')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FV7206BDDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1465</td>\n",
       "      <td>2651</td>\n",
       "      <td>4664</td>\n",
       "      <td>1785</td>\n",
       "      <td>1480</td>\n",
       "      <td>1984</td>\n",
       "      <td>147</td>\n",
       "      <td>LFV3A21K×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2651</td>\n",
       "      <td>4664x1785x1480</td>\n",
       "      <td>大众</td>\n",
       "      <td>速腾</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FV7206BDDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1465</td>\n",
       "      <td>2651</td>\n",
       "      <td>4664</td>\n",
       "      <td>1785</td>\n",
       "      <td>1480</td>\n",
       "      <td>1984</td>\n",
       "      <td>147</td>\n",
       "      <td>LFV3A21K×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2651</td>\n",
       "      <td>4664x1785x1480</td>\n",
       "      <td>大众</td>\n",
       "      <td>速腾</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>FV7206BDDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1465</td>\n",
       "      <td>2651</td>\n",
       "      <td>4664</td>\n",
       "      <td>1785</td>\n",
       "      <td>1480</td>\n",
       "      <td>1984</td>\n",
       "      <td>147</td>\n",
       "      <td>LFV3A21K×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2651</td>\n",
       "      <td>4664x1785x1480</td>\n",
       "      <td>大众</td>\n",
       "      <td>速腾</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FV7142BCMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1285</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FV7152BABBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1265</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1498</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FV7152BAMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1230</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1498</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>FV7142BBDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1310</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>FV7162BAMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1220</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FV7142BBMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1285</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FV7162BABBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1260</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>FV7142BBDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1310</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>FV7142BCMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1285</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>FV7152BABBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1265</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1498</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>FV7152BAMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1230</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1498</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>FV7142BCMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1285</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>FV7152BABBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1265</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1498</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>FV7152BAMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1230</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1498</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>FV7142BBDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1310</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>FV7162BABBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1260</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>FV7162BABBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1260</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>FV7162BAMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1220</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>FV7142BBMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1285</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>FV7142BBDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1310</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>FV7162BAMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1220</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>FV7142BBMBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1285</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A115×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>FV7162BABBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1260</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>FV7142BBDBG</td>\n",
       "      <td>大众</td>\n",
       "      <td>1310</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LFV2A215×××××××××</td>\n",
       "      <td>一汽-大众汽车有限公司</td>\n",
       "      <td>LFV</td>\n",
       "      <td>2614</td>\n",
       "      <td>4562x1793x1468</td>\n",
       "      <td>大众</td>\n",
       "      <td>宝来</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>SVW71417JL</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1270</td>\n",
       "      <td>2610</td>\n",
       "      <td>4605</td>\n",
       "      <td>1765</td>\n",
       "      <td>1460</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LSVWP418×××××××××,LSVWP218×××××××××,LSVWP618××...</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2610</td>\n",
       "      <td>4605x1765x1460</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>SVW71617SM</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1245</td>\n",
       "      <td>2610</td>\n",
       "      <td>4605</td>\n",
       "      <td>1765</td>\n",
       "      <td>1460</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LSVWB418×××××××××,LSVWB218×××××××××,LSVWB618××...</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2610</td>\n",
       "      <td>4605x1765x1460</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>SVW71417AL</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1270</td>\n",
       "      <td>2610</td>\n",
       "      <td>4605</td>\n",
       "      <td>1765</td>\n",
       "      <td>1460</td>\n",
       "      <td>1395</td>\n",
       "      <td>96</td>\n",
       "      <td>LSVWE418×××××××××,LSVWE218×××××××××,LSVWE618××...</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2610</td>\n",
       "      <td>4605x1765x1460</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>SVW6451DED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1520</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXY25N×××××××××,LSVXY65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>SVW6451EED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1600</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXZ25N×××××××××,LSVXZ65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>SVW6451JED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1710</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVX025N×××××××××,LSVX065N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>SVW6451KFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1720</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1984</td>\n",
       "      <td>147</td>\n",
       "      <td>LSVX125N×××××××××,LSVX165N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>SVW6451DED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1520</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXY25N×××××××××,LSVXY65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>SVW6451EED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1600</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXZ25N×××××××××,LSVXZ65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>SVW6451AGD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1500</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1390</td>\n",
       "      <td>96</td>\n",
       "      <td>LSVXX25N×××××××××,LSVXX65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>SVW6451JED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1710</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVX025N×××××××××,LSVX065N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055</th>\n",
       "      <td>SVW6451XED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1600</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXU25N×××××××××,LSVXU65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>SVW6451YED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1710</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXV25N×××××××××,LSVXV65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>SVW6451WED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1520</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXT25N×××××××××,LSVXT65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1058</th>\n",
       "      <td>SVW6451ZFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1720</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1984</td>\n",
       "      <td>147</td>\n",
       "      <td>LSVXW25N×××××××××,LSVXW65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>SVW6451VGD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1500</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1390</td>\n",
       "      <td>96</td>\n",
       "      <td>LSVXS25N×××××××××,LSVXS65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>SVW6451UFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1720</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1984</td>\n",
       "      <td>147</td>\n",
       "      <td>LSVXN25N×××××××××,LSVXN65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>SVW6451QGD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1500</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1390</td>\n",
       "      <td>96</td>\n",
       "      <td>LSVXR25N×××××××××,LSVXR65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>SVW6451RED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1520</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXK25N×××××××××,LSVXK65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>SVW6451TED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1710</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXM25N×××××××××,LSVXM65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>SVW6451SED</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1600</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506</td>\n",
       "      <td>1809</td>\n",
       "      <td>1685</td>\n",
       "      <td>1798</td>\n",
       "      <td>118</td>\n",
       "      <td>LSVXL25N×××××××××,LSVXL65N×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2684</td>\n",
       "      <td>4506x1809x1685</td>\n",
       "      <td>大众</td>\n",
       "      <td>途观</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>SVW6505BFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1945</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>1984</td>\n",
       "      <td>137</td>\n",
       "      <td>LSV1A6CA×××××××××,LSV1A8CA×××××××××</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>SVW6505EFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>2025</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>1984</td>\n",
       "      <td>162</td>\n",
       "      <td>LSV1B6CA×××××××××,LSV1B8CA×××××××××</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>SVW6505HHD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>2125</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>2492</td>\n",
       "      <td>220</td>\n",
       "      <td>LSV1C8CA×××××××××</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>SVW6505JHD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>2125</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>2492</td>\n",
       "      <td>220</td>\n",
       "      <td>LSV2C7CA×××××××××,LSV2C8CA×××××××××</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>SVW6505CFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1945</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>1984</td>\n",
       "      <td>137</td>\n",
       "      <td>LSV2A6CA×××××××××,LSV2A7CA×××××××××,LSV2A8CA××...</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>SVW6505AFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1875</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>1984</td>\n",
       "      <td>137</td>\n",
       "      <td>LSVUA6CA×××××××××,LSVUA7CA×××××××××,LSVUA8CA××...</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>SVW6505DFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1955</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>1984</td>\n",
       "      <td>162</td>\n",
       "      <td>LSVUB6CA×××××××××,LSVUB7CA×××××××××,LSVUB8CA××...</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1072</th>\n",
       "      <td>SVW6505FFD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>2025</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039</td>\n",
       "      <td>1989</td>\n",
       "      <td>1773</td>\n",
       "      <td>1984</td>\n",
       "      <td>162</td>\n",
       "      <td>LSV2B6CA×××××××××,LSV2B7CA×××××××××,LSV2B8CA××...</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2980</td>\n",
       "      <td>5039x1989x1773</td>\n",
       "      <td>大众</td>\n",
       "      <td>途昂</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1073</th>\n",
       "      <td>SVW6440FCD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1390</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395</td>\n",
       "      <td>1794</td>\n",
       "      <td>1634</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LSVRZ41T×××××××××</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395x1794x1634</td>\n",
       "      <td>大众</td>\n",
       "      <td>途安</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1074</th>\n",
       "      <td>SVW6440ECD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1425</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395</td>\n",
       "      <td>1794</td>\n",
       "      <td>1634</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LSVRL41T×××××××××</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395x1794x1634</td>\n",
       "      <td>大众</td>\n",
       "      <td>途安</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1075</th>\n",
       "      <td>SVW6440ECD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1425</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395</td>\n",
       "      <td>1794</td>\n",
       "      <td>1634</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LSVRL41T×××××××××</td>\n",
       "      <td>上汽大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395x1794x1634</td>\n",
       "      <td>大众</td>\n",
       "      <td>途安</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1076</th>\n",
       "      <td>SVW6440ECD</td>\n",
       "      <td>大众汽车(VOLKSWAGEN)</td>\n",
       "      <td>1425</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395</td>\n",
       "      <td>1794</td>\n",
       "      <td>1634</td>\n",
       "      <td>1598</td>\n",
       "      <td>81</td>\n",
       "      <td>LSVRL41T×××××××××</td>\n",
       "      <td>上海大众汽车有限公司</td>\n",
       "      <td>LSV</td>\n",
       "      <td>2678</td>\n",
       "      <td>4395x1794x1634</td>\n",
       "      <td>大众</td>\n",
       "      <td>途安</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1077 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      notice_type           brand_x curb_weight Wheelbase car_length  \\\n",
       "0     FV7206BDDBG                大众        1465      2651       4664   \n",
       "1     FV7206BDDBG                大众        1465      2651       4664   \n",
       "2     FV7206BDDBG                大众        1465      2651       4664   \n",
       "3     FV7142BCMBG                大众        1285      2614       4562   \n",
       "4     FV7152BABBG                大众        1265      2614       4562   \n",
       "5     FV7152BAMBG                大众        1230      2614       4562   \n",
       "6     FV7142BBDBG                大众        1310      2614       4562   \n",
       "7     FV7162BAMBG                大众        1220      2614       4562   \n",
       "8     FV7142BBMBG                大众        1285      2614       4562   \n",
       "9     FV7162BABBG                大众        1260      2614       4562   \n",
       "10    FV7142BBDBG                大众        1310      2614       4562   \n",
       "11    FV7142BCMBG                大众        1285      2614       4562   \n",
       "12    FV7152BABBG                大众        1265      2614       4562   \n",
       "13    FV7152BAMBG                大众        1230      2614       4562   \n",
       "14    FV7142BCMBG                大众        1285      2614       4562   \n",
       "15    FV7152BABBG                大众        1265      2614       4562   \n",
       "16    FV7152BAMBG                大众        1230      2614       4562   \n",
       "17    FV7142BBDBG                大众        1310      2614       4562   \n",
       "18    FV7162BABBG                大众        1260      2614       4562   \n",
       "19    FV7162BABBG                大众        1260      2614       4562   \n",
       "20    FV7162BAMBG                大众        1220      2614       4562   \n",
       "21    FV7142BBMBG                大众        1285      2614       4562   \n",
       "22    FV7142BBDBG                大众        1310      2614       4562   \n",
       "23    FV7162BAMBG                大众        1220      2614       4562   \n",
       "24    FV7142BBMBG                大众        1285      2614       4562   \n",
       "25    FV7162BABBG                大众        1260      2614       4562   \n",
       "26    FV7142BBDBG                大众        1310      2614       4562   \n",
       "27     SVW71417JL  大众汽车(VOLKSWAGEN)        1270      2610       4605   \n",
       "28     SVW71617SM  大众汽车(VOLKSWAGEN)        1245      2610       4605   \n",
       "29     SVW71417AL  大众汽车(VOLKSWAGEN)        1270      2610       4605   \n",
       "...           ...               ...         ...       ...        ...   \n",
       "1047   SVW6451DED  大众汽车(VOLKSWAGEN)        1520      2684       4506   \n",
       "1048   SVW6451EED  大众汽车(VOLKSWAGEN)        1600      2684       4506   \n",
       "1049   SVW6451JED  大众汽车(VOLKSWAGEN)        1710      2684       4506   \n",
       "1050   SVW6451KFD  大众汽车(VOLKSWAGEN)        1720      2684       4506   \n",
       "1051   SVW6451DED  大众汽车(VOLKSWAGEN)        1520      2684       4506   \n",
       "1052   SVW6451EED  大众汽车(VOLKSWAGEN)        1600      2684       4506   \n",
       "1053   SVW6451AGD  大众汽车(VOLKSWAGEN)        1500      2684       4506   \n",
       "1054   SVW6451JED  大众汽车(VOLKSWAGEN)        1710      2684       4506   \n",
       "1055   SVW6451XED  大众汽车(VOLKSWAGEN)        1600      2684       4506   \n",
       "1056   SVW6451YED  大众汽车(VOLKSWAGEN)        1710      2684       4506   \n",
       "1057   SVW6451WED  大众汽车(VOLKSWAGEN)        1520      2684       4506   \n",
       "1058   SVW6451ZFD  大众汽车(VOLKSWAGEN)        1720      2684       4506   \n",
       "1059   SVW6451VGD  大众汽车(VOLKSWAGEN)        1500      2684       4506   \n",
       "1060   SVW6451UFD  大众汽车(VOLKSWAGEN)        1720      2684       4506   \n",
       "1061   SVW6451QGD  大众汽车(VOLKSWAGEN)        1500      2684       4506   \n",
       "1062   SVW6451RED  大众汽车(VOLKSWAGEN)        1520      2684       4506   \n",
       "1063   SVW6451TED  大众汽车(VOLKSWAGEN)        1710      2684       4506   \n",
       "1064   SVW6451SED  大众汽车(VOLKSWAGEN)        1600      2684       4506   \n",
       "1065   SVW6505BFD  大众汽车(VOLKSWAGEN)        1945      2980       5039   \n",
       "1066   SVW6505EFD  大众汽车(VOLKSWAGEN)        2025      2980       5039   \n",
       "1067   SVW6505HHD  大众汽车(VOLKSWAGEN)        2125      2980       5039   \n",
       "1068   SVW6505JHD  大众汽车(VOLKSWAGEN)        2125      2980       5039   \n",
       "1069   SVW6505CFD  大众汽车(VOLKSWAGEN)        1945      2980       5039   \n",
       "1070   SVW6505AFD  大众汽车(VOLKSWAGEN)        1875      2980       5039   \n",
       "1071   SVW6505DFD  大众汽车(VOLKSWAGEN)        1955      2980       5039   \n",
       "1072   SVW6505FFD  大众汽车(VOLKSWAGEN)        2025      2980       5039   \n",
       "1073   SVW6440FCD  大众汽车(VOLKSWAGEN)        1390      2678       4395   \n",
       "1074   SVW6440ECD  大众汽车(VOLKSWAGEN)        1425      2678       4395   \n",
       "1075   SVW6440ECD  大众汽车(VOLKSWAGEN)        1425      2678       4395   \n",
       "1076   SVW6440ECD  大众汽车(VOLKSWAGEN)        1425      2678       4395   \n",
       "\n",
       "     car_width car_height Displacement power  \\\n",
       "0         1785       1480         1984   147   \n",
       "1         1785       1480         1984   147   \n",
       "2         1785       1480         1984   147   \n",
       "3         1793       1468         1395    96   \n",
       "4         1793       1468         1498    81   \n",
       "5         1793       1468         1498    81   \n",
       "6         1793       1468         1395    96   \n",
       "7         1793       1468         1598    81   \n",
       "8         1793       1468         1395    96   \n",
       "9         1793       1468         1598    81   \n",
       "10        1793       1468         1395    96   \n",
       "11        1793       1468         1395    96   \n",
       "12        1793       1468         1498    81   \n",
       "13        1793       1468         1498    81   \n",
       "14        1793       1468         1395    96   \n",
       "15        1793       1468         1498    81   \n",
       "16        1793       1468         1498    81   \n",
       "17        1793       1468         1395    96   \n",
       "18        1793       1468         1598    81   \n",
       "19        1793       1468         1598    81   \n",
       "20        1793       1468         1598    81   \n",
       "21        1793       1468         1395    96   \n",
       "22        1793       1468         1395    96   \n",
       "23        1793       1468         1598    81   \n",
       "24        1793       1468         1395    96   \n",
       "25        1793       1468         1598    81   \n",
       "26        1793       1468         1395    96   \n",
       "27        1765       1460         1395    96   \n",
       "28        1765       1460         1598    81   \n",
       "29        1765       1460         1395    96   \n",
       "...        ...        ...          ...   ...   \n",
       "1047      1809       1685         1798   118   \n",
       "1048      1809       1685         1798   118   \n",
       "1049      1809       1685         1798   118   \n",
       "1050      1809       1685         1984   147   \n",
       "1051      1809       1685         1798   118   \n",
       "1052      1809       1685         1798   118   \n",
       "1053      1809       1685         1390    96   \n",
       "1054      1809       1685         1798   118   \n",
       "1055      1809       1685         1798   118   \n",
       "1056      1809       1685         1798   118   \n",
       "1057      1809       1685         1798   118   \n",
       "1058      1809       1685         1984   147   \n",
       "1059      1809       1685         1390    96   \n",
       "1060      1809       1685         1984   147   \n",
       "1061      1809       1685         1390    96   \n",
       "1062      1809       1685         1798   118   \n",
       "1063      1809       1685         1798   118   \n",
       "1064      1809       1685         1798   118   \n",
       "1065      1989       1773         1984   137   \n",
       "1066      1989       1773         1984   162   \n",
       "1067      1989       1773         2492   220   \n",
       "1068      1989       1773         2492   220   \n",
       "1069      1989       1773         1984   137   \n",
       "1070      1989       1773         1984   137   \n",
       "1071      1989       1773         1984   162   \n",
       "1072      1989       1773         1984   162   \n",
       "1073      1794       1634         1598    81   \n",
       "1074      1794       1634         1598    81   \n",
       "1075      1794       1634         1598    81   \n",
       "1076      1794       1634         1598    81   \n",
       "\n",
       "                                                    vin  car_factory    3  \\\n",
       "0                                     LFV3A21K×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "1                                     LFV3A21K×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "2                                     LFV3A21K×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "3                                     LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "4                                     LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "5                                     LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "6                                     LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "7                                     LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "8                                     LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "9                                     LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "10                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "11                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "12                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "13                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "14                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "15                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "16                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "17                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "18                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "19                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "20                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "21                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "22                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "23                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "24                                    LFV2A115×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "25                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "26                                    LFV2A215×××××××××  一汽-大众汽车有限公司  LFV   \n",
       "27    LSVWP418×××××××××,LSVWP218×××××××××,LSVWP618××...   上汽大众汽车有限公司  LSV   \n",
       "28    LSVWB418×××××××××,LSVWB218×××××××××,LSVWB618××...   上汽大众汽车有限公司  LSV   \n",
       "29    LSVWE418×××××××××,LSVWE218×××××××××,LSVWE618××...   上汽大众汽车有限公司  LSV   \n",
       "...                                                 ...          ...  ...   \n",
       "1047                LSVXY25N×××××××××,LSVXY65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1048                LSVXZ25N×××××××××,LSVXZ65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1049                LSVX025N×××××××××,LSVX065N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1050                LSVX125N×××××××××,LSVX165N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1051                LSVXY25N×××××××××,LSVXY65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1052                LSVXZ25N×××××××××,LSVXZ65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1053                LSVXX25N×××××××××,LSVXX65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1054                LSVX025N×××××××××,LSVX065N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1055                LSVXU25N×××××××××,LSVXU65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1056                LSVXV25N×××××××××,LSVXV65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1057                LSVXT25N×××××××××,LSVXT65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1058                LSVXW25N×××××××××,LSVXW65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1059                LSVXS25N×××××××××,LSVXS65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1060                LSVXN25N×××××××××,LSVXN65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1061                LSVXR25N×××××××××,LSVXR65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1062                LSVXK25N×××××××××,LSVXK65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1063                LSVXM25N×××××××××,LSVXM65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1064                LSVXL25N×××××××××,LSVXL65N×××××××××   上海大众汽车有限公司  LSV   \n",
       "1065                LSV1A6CA×××××××××,LSV1A8CA×××××××××   上汽大众汽车有限公司  LSV   \n",
       "1066                LSV1B6CA×××××××××,LSV1B8CA×××××××××   上汽大众汽车有限公司  LSV   \n",
       "1067                                  LSV1C8CA×××××××××   上汽大众汽车有限公司  LSV   \n",
       "1068                LSV2C7CA×××××××××,LSV2C8CA×××××××××   上汽大众汽车有限公司  LSV   \n",
       "1069  LSV2A6CA×××××××××,LSV2A7CA×××××××××,LSV2A8CA××...   上汽大众汽车有限公司  LSV   \n",
       "1070  LSVUA6CA×××××××××,LSVUA7CA×××××××××,LSVUA8CA××...   上汽大众汽车有限公司  LSV   \n",
       "1071  LSVUB6CA×××××××××,LSVUB7CA×××××××××,LSVUB8CA××...   上汽大众汽车有限公司  LSV   \n",
       "1072  LSV2B6CA×××××××××,LSV2B7CA×××××××××,LSV2B8CA××...   上汽大众汽车有限公司  LSV   \n",
       "1073                                  LSVRZ41T×××××××××   上汽大众汽车有限公司  LSV   \n",
       "1074                                  LSVRL41T×××××××××   上汽大众汽车有限公司  LSV   \n",
       "1075                                  LSVRL41T×××××××××   上汽大众汽车有限公司  LSV   \n",
       "1076                                  LSVRL41T×××××××××   上海大众汽车有限公司  LSV   \n",
       "\n",
       "     轴距[mm]       长×宽×高[mm] brand_y style  factory  \n",
       "0      2651  4664x1785x1480      大众    速腾        1  \n",
       "1      2651  4664x1785x1480      大众    速腾        1  \n",
       "2      2651  4664x1785x1480      大众    速腾        1  \n",
       "3      2614  4562x1793x1468      大众    宝来       23  \n",
       "4      2614  4562x1793x1468      大众    宝来       23  \n",
       "5      2614  4562x1793x1468      大众    宝来       23  \n",
       "6      2614  4562x1793x1468      大众    宝来       23  \n",
       "7      2614  4562x1793x1468      大众    宝来       23  \n",
       "8      2614  4562x1793x1468      大众    宝来       23  \n",
       "9      2614  4562x1793x1468      大众    宝来       23  \n",
       "10     2614  4562x1793x1468      大众    宝来       23  \n",
       "11     2614  4562x1793x1468      大众    宝来       23  \n",
       "12     2614  4562x1793x1468      大众    宝来       23  \n",
       "13     2614  4562x1793x1468      大众    宝来       23  \n",
       "14     2614  4562x1793x1468      大众    宝来       23  \n",
       "15     2614  4562x1793x1468      大众    宝来       23  \n",
       "16     2614  4562x1793x1468      大众    宝来       23  \n",
       "17     2614  4562x1793x1468      大众    宝来       23  \n",
       "18     2614  4562x1793x1468      大众    宝来       23  \n",
       "19     2614  4562x1793x1468      大众    宝来       23  \n",
       "20     2614  4562x1793x1468      大众    宝来       23  \n",
       "21     2614  4562x1793x1468      大众    宝来       23  \n",
       "22     2614  4562x1793x1468      大众    宝来       23  \n",
       "23     2614  4562x1793x1468      大众    宝来       23  \n",
       "24     2614  4562x1793x1468      大众    宝来       23  \n",
       "25     2614  4562x1793x1468      大众    宝来       23  \n",
       "26     2614  4562x1793x1468      大众    宝来       23  \n",
       "27     2610  4605x1765x1460      大众    朗逸       39  \n",
       "28     2610  4605x1765x1460      大众    朗逸       39  \n",
       "29     2610  4605x1765x1460      大众    朗逸       39  \n",
       "...     ...             ...     ...   ...      ...  \n",
       "1047   2684  4506x1809x1685      大众    途观       25  \n",
       "1048   2684  4506x1809x1685      大众    途观       25  \n",
       "1049   2684  4506x1809x1685      大众    途观       25  \n",
       "1050   2684  4506x1809x1685      大众    途观       25  \n",
       "1051   2684  4506x1809x1685      大众    途观       25  \n",
       "1052   2684  4506x1809x1685      大众    途观       25  \n",
       "1053   2684  4506x1809x1685      大众    途观       25  \n",
       "1054   2684  4506x1809x1685      大众    途观       25  \n",
       "1055   2684  4506x1809x1685      大众    途观       25  \n",
       "1056   2684  4506x1809x1685      大众    途观       25  \n",
       "1057   2684  4506x1809x1685      大众    途观       25  \n",
       "1058   2684  4506x1809x1685      大众    途观       25  \n",
       "1059   2684  4506x1809x1685      大众    途观       25  \n",
       "1060   2684  4506x1809x1685      大众    途观       25  \n",
       "1061   2684  4506x1809x1685      大众    途观       25  \n",
       "1062   2684  4506x1809x1685      大众    途观       25  \n",
       "1063   2684  4506x1809x1685      大众    途观       25  \n",
       "1064   2684  4506x1809x1685      大众    途观       25  \n",
       "1065   2980  5039x1989x1773      大众    途昂        9  \n",
       "1066   2980  5039x1989x1773      大众    途昂        9  \n",
       "1067   2980  5039x1989x1773      大众    途昂        9  \n",
       "1068   2980  5039x1989x1773      大众    途昂        9  \n",
       "1069   2980  5039x1989x1773      大众    途昂        9  \n",
       "1070   2980  5039x1989x1773      大众    途昂        9  \n",
       "1071   2980  5039x1989x1773      大众    途昂        9  \n",
       "1072   2980  5039x1989x1773      大众    途昂        9  \n",
       "1073   2678  4395x1794x1634      大众    途安        2  \n",
       "1074   2678  4395x1794x1634      大众    途安        2  \n",
       "1075   2678  4395x1794x1634      大众    途安        2  \n",
       "1076   2678  4395x1794x1634      大众    途安        2  \n",
       "\n",
       "[1077 rows x 17 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('丰田_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('大众_VIN.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
